{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Opérations","Entrées","Marchandise","Sorties","Client","Facture","Inventaire","tableau de bord","synthèse"],"not_rendered":{"charts":6,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Opérations","index":0,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[3,5,6,9]]}
[]
[]
[]
[null,null,null,null,null,"Nouvelle Opération"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Référence",null,"Date"]
[]
[null,null,null,null,null,null,"désignation",null,"prix unitaire"]
[]
[null,null,null,null,null,null,"Catégorie",null,"Quantité"]
[]
[null,null,null,null,null,null,"Q. Stock Initial"," ","P.stock InitIal"]

{"sheet":"Entrées","index":1,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[[4,3,11,11]]}
[]
[]
[]
[]
[null,null,null,"Tableau des Achats"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Numéro","Date","Référence","Désignation","Catégorie","Prix.Unitaire","Quantité"," Q.Stock initial","P.Stock Inital"]
[]
[]
[]
[]
[]
[null,null,null,"merci de supprimer aprée lire"]
[null,null,null,"à ne pas ajouter ou supprimer les lignes"]
[null,null,null,"Seules les lignes insérées après la ligne 17 peuvent être annulées"]
[null,null,null,null,"       "]

{"sheet":"Marchandise","index":2,"n_rows":28,"n_cols":13,"rows_kept":28,"cut":false,"hidden":false,"merged":[[17,5,18,9],[5,3,11,11]]}
[]
[]
[]
[]
[]
[null,null,null,"Tableau des Mouvements  \"Marchandises\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Référence","Désignation","Catégorie","Prix d'Achat","Q.Stock initial","Etat","Unité Acheté","Prix de vente","Unité vendu","Unité Restant"]
[]
[]
[null,null,null,null,"merci de supprimer aprée lire"]
[null,null,null,null,"à ne pas ajouter ou supprimer les lignes"]
[null,null,null,null,"Seules les lignes insérées après la ligne 23 peuvent être annulées"]
[null,null,null,null,null,"       "]

{"sheet":"Sorties","index":3,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":false,"merged":[[5,3,11,11]]}
[]
[]
[]
[]
[]
[null,null,null,"Tableau des Ventes"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Client",null,"Catégorie Produit"]
[null,null,null,null,"Date de vente",null,"Type d'opération"]
[null,null,null,null,"Réference",null,"Prix de vente"]
[null,null,null,null,"Désignation",null,"Quantité Vendu"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Référence","Date","Client","Désignation","Catégorie Produit","Type d'opération","Prix de vente","Quantité","Total"]
[]
[]
[]
[null,null,null,null,"merci de supprimer aprée lire"]
[null,null,null,null,"à ne pas ajouter ou supprimer les lignes"]
[null,null,null,null,"Seules les lignes insérées après la ligne 31 peuvent être annulées"]

{"sheet":"Client","index":4,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[5,3,11,11],[12,3,13,11]]}
[]
[]
[]
[]
[]
[null,null,null,"LISTES DES CLIENTS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Client",null,"Email"]
[null,null,null,null,"Siége",null,"RC"]
[null,null,null,null,"Tél",null,"GSM"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Client","Siége","Tél","Email","RC","GSM"]
[]
[]
[]
[]
[]
[null,null,null,null,"merci de supprimer aprée lire"]
[null,null,null,null,"à ne pas ajouter ou supprimer les lignes"]
[null,null,null,null,"Seules les lignes insérées après la ligne 27 peuvent être annulées"]

{"sheet":"Facture","index":5,"n_rows":29,"n_cols":16,"rows_kept":29,"cut":false,"hidden":false,"merged":[[22,5,22,6],[26,6,26,7],[27,6,27,7],[28,6,28,7]]}
[]
[null,null,null,null,null,{"$error":"#VALUE!"},"   FACTURE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mois","2025-04-01"]
[]
[null,null,null,null,null,"à ne pas supprimer ou modifier cette facture",null,"FACTURER À"]
[null,null,null,null,null,"ajouter juste vos cordonées et logo  d'entreprise",null,"Client:"]
[null,null,null,null,null,"merci de supprimer après  lire",null,"Raison Sociale:",null,null,null,null,null,"TVA",0.2]
[null,null,null,null,null,null,null,"Téléphone:",null,null,null,null,null,null,"à modifier"]
[null,null,null,null,null,null,null,"EMAIL:"]
[null,null,null,null,null,null,null,"RC:"]
[null,null,null,null,null,null,null,"GSM:"]
[]
[]
[null,null,null,null,null,"FACTURE  N°:"]
[]
[null,null,null,null,null,"Description","Qauntité","Prix unitaire ","Total de la ligne "]
[null,null,null,null,null,null,null,null,{"$f":"+H17*G17","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Adresse de corrier","Compte bancaire"]
[null,null,null,null,null,"Tél","RC"]
[null,null,null,null,null,"Raison Sociale","Taxe"]

{"sheet":"Inventaire","index":6,"n_rows":32,"n_cols":16,"rows_kept":32,"cut":false,"hidden":false,"merged":[[3,3,10,15]]}
[]
[]
[]
[null,null,null,"Tableau d'Inventaire"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Référence"]
[]
[null,null,null,null,null,null,null,null,null,"Trimestre"]
[]
[]
[]
[]
[null,"Trimestre","Référence","Désignation","Catégorie","Q.Stock Initial","P.stock inital","Alerte Stock","Qauntié Total des Achats","Valeur Total des Achats","Quantité Total Vendue","Stock Actuel ","Valeur Total des Ventes","Marge Brute","Valeur du Stock Actuel","Prix moyen pondéré"]
[]
[]
[]
[]
[]
[null,null,null,null,"merci de supprimer aprée lire"]
[null,null,null,null,"à ne pas ajouter ou supprimer des lignes"]
[null,null,null,null,"Seules les lignes insérées après la ligne 25 peuvent être annulées"]

{"sheet":"tableau de bord","index":7,"n_rows":6,"n_cols":36,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mois","Achats","Ventes"]
[null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,20,105,null,null,0,null,null,null,null,0]
[null,null,null,null,null,"Qunatité Total des Produits",null,null,null,null,"Valeur Total des Achats",null,null,null,null,"Quantité Total Vendus",null,null,null,null,"Valeurs  Total des Ventes",null,null,null,null,"2025-04",0,0,null,null,"Valeur du Stock Actuel",null,null,null,null,"Prix Moyen Pondéré"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-07",20,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-06",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-05",0,3]

{"sheet":"synthèse","index":8,"n_rows":6,"n_cols":22,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Achats",0,null,null,null,null,null,"Mois","Total Achats",null,"Mois","Total Ventes"]
["Ventes",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trimestre","Marge brute"]
["Stocks",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trimestre 1",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trimestre 2",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trimestre 3",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trimestre 4",0]